from openpyxl import load_workbook

workbook = load_workbook(filename='富乐学校小学部.xlsx')
names = workbook.sheetnames
for y in names:
    for i in workbook[f'{y}'].rows:
        if i[5].value is None or i[5].value == '身份证号' or i[5].value == 0:
            pass
        else:
            i[7].value = 2023 - int(i[5].value[6:10])
            if i[7].value > 100:
                print(y)

workbook.save(filename='富乐学校小学部.xlsx')


